# -*- coding: utf-8 -*-

from scrapy.item import Item, Field


class Profession(Item):  # 小区基本信息
    table = Field()  # t_major
    name = Field()
    url = Field()
    type = Field()
    level = Field()
    code = Field()
    diploma = Field()
    age = Field()
    course = Field()
    intro = Field()
    job = Field()


class University(Item):
    table = Field()
    fid = Field()  # 对应平台id
    url = Field()  # 网站url
    name = Field()  # 大学名称
    ename = Field()  # 大学英文名
    rank = Field()  # 排名
    category = Field()  # 院校分类。综合
    feature = Field()  # 院校特色。211
    isgov = Field()  # 1：公办；2：民办
    ismajor = Field()  # 1：本科；2：专科
    province = Field()  # 省
    city = Field()  # 城市
    cityinfo = Field()
    address = Field()  # 地址
    tel = Field()  # 电话
    email = Field()  # 邮箱
    gov_url = Field()  # 官网地址
    enroll_url = Field()  # 招生网站
    coordinate = Field()  # 学校坐标
    logo = Field()  # logo地址
    intro = Field()  # 学校详情
    found_time = Field()  # 创建年份
    subjection = Field()  # 隶属于
    student = Field()  # 学生人数
    academician = Field()  # 院士人数
    key_course = Field()  # 重点学科
    doctor = Field()  # 博士点
    master = Field()  # 硕士点
    job = Field()  # 就业情况
    come_data = Field()  # 学生来源
    male_female = Field()  # 男女比例
    fee = Field()  # 学费
    regulations = Field()  # 招生简章
    oneself = Field()  # 自主招生
    recommend = Field()  # 保送生
    excellent = Field()  # 特长生


class UPoint(Item):
    table = Field()  # t_university_point
    fid = Field()
    type = Field()
    tips = Field()
    name = Field()
    content = Field()
    code = Field()


class UProfession(Item):
    table = Field()  # t_university_major
    fid = Field()
    url = Field()
    kind = Field()
    name = Field()
    type = Field()  # 2:本科；1:专科
    content = Field()
    code = Field()


class Guide(Item):
    table = Field()
    fid = Field()
    year = Field()
    type = Field()
    title = Field()
    content = Field()


class HistoryData(Item):
    table = Field()  # t_university_history_data
    fid = Field()
    provinceid = Field()  # 省
    type = Field()  # 1:理科；2:文科
    year = Field()  # 年
    batch = Field()  # 批次
    average = Field()  # 平均分
    lower = Field()  # 最低分
    student = Field()  # 录取人数
    line = Field()  # 省控线


class ProfessionData(Item):
    table = Field()  # t_university_profession_data
    fid = Field()
    provinceid = Field()  # 省
    type = Field()  # 1:理科；2:文科
    name = Field()  # 专业
    year = Field()  # 年
    batch = Field()  # 批次
    average = Field()  # 平均分
    upper = Field()  # 最高分


class Admission(Item):
    table = Field()  # t_admission
    provinceid = Field()
    provincename = Field()
    year = Field()
    type = Field()
    name = Field()
    score = Field()


class Scholarship(Item):
    table = Field()  # t_scholarship
    name = Field()
    title = Field()
    amount = Field()
    standard = Field()
    people = Field()


class StudentPlan(Item):
    table = Field()  # t_university_student_plan
    fid = Field()
    bk_name = Field()
    bk_id = Field()
    provinceid = Field()
    type = Field()
    year = Field()
    major = Field()
    code = Field()
    count = Field()


class BKUniversity(Item):
    table = Field()  # t_bk_university
    name = Field()
    cid = Field()


class ZhihuItem(Item):
    # define the fields for your item here like:
    # name = scrapy.Field()
    url = Field()  # 保存抓取问题的url
    title = Field()  # 抓取问题的标题
    description = Field()  # 抓取问题的描述
    answer = Field()  # 抓取问题的答案
    name = Field()  # 个人用户的名称


class ScrapyUniversityItem(Item):
    table   = Field()
    name    = Field()
    id  = Field()
    url  = Field()
    diploma  = Field()
    sch_id  = Field()

class ScrapyScoreLineItem(Item):
    table   = Field()
    university_name    = Field()
    province_name  = Field()
    year  = Field()
    average_score  = Field()
    minimum_score  = Field()
    provincial_line  = Field()
    minimum_score_ranking  = Field()
    people_number  = Field()
    batch  = Field()
    type  = Field()
class ScrapyScoreItem(Item):
    table   = Field()
    name    = Field()
    sch_id  = Field()
    url  = Field()
    diploma  = Field()
    province_name  = Field()
    number  = Field()
